Overview
Brought to you by YData
Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 21210 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.6 MiB |
| Average record size in memory | 180.0 B |
Variable types
| Numeric | 18 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
price is highly overall correlated with grade and 3 other fields | High correlation |
bedrooms is highly overall correlated with bathrooms and 2 other fields | High correlation |
bathrooms is highly overall correlated with age and 7 other fields | High correlation |
sqft_living is highly overall correlated with bathrooms and 5 other fields | High correlation |
sqft_lot is highly overall correlated with sqft_lot15 | High correlation |
floors is highly overall correlated with age and 3 other fields | High correlation |
grade is highly overall correlated with age and 6 other fields | High correlation |
sqft_above is highly overall correlated with bathrooms and 6 other fields | High correlation |
yr_built is highly overall correlated with age and 3 other fields | High correlation |
zipcode is highly overall correlated with long | High correlation |
long is highly overall correlated with zipcode | High correlation |
sqft_living15 is highly overall correlated with bathrooms and 4 other fields | High correlation |
sqft_lot15 is highly overall correlated with sqft_lot | High correlation |
age is highly overall correlated with bathrooms and 3 other fields | High correlation |
condition is highly overall correlated with yr_built and 1 other fields | High correlation |
sqft_basement is highly overall correlated with sqft_living | High correlation |
lat is highly overall correlated with price and 1 other fields | High correlation |
waterfront is highly imbalanced (96.6%) | Imbalance |
view is highly imbalanced (74.0%) | Imbalance |
id has unique values | Unique |
sqft_basement has 12955 (61.1%) zeros | Zeros |
yr_renovated has 20369 (96.0%) zeros | Zeros |
age has 530 (2.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-29 15:37:53.281556 |
|---|---|
| Analysis finished | 2024-11-29 15:38:11.181214 |
| Duration | 17.9 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
Unique 
| Distinct | 21210 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5876091 × 109 |
| Minimum | 1000102 |
|---|---|
| Maximum | 9.9000002 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 1000102 |
|---|---|
| 5-th percentile | 5.1000251 × 108 |
| Q1 | 2.1250591 × 109 |
| median | 3.9050004 × 109 |
| Q3 | 7.3124001 × 109 |
| 95-th percentile | 9.2973011 × 109 |
| Maximum | 9.9000002 × 109 |
| Range | 9.8990001 × 109 |
| Interquartile range (IQR) | 5.187341 × 109 |
Descriptive statistics
| Standard deviation | 2.8763082 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.62697326 |
| Kurtosis | -1.262218 |
| Mean | 4.5876091 × 109 |
| Median Absolute Deviation (MAD) | 2.4066965 × 109 |
| Skewness | 0.23959282 |
| Sum | 9.7303189 × 1013 |
| Variance | 8.273149 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7129300520 | 1 | < 0.1% |
| 2064800610 | 1 | < 0.1% |
| 3213200180 | 1 | < 0.1% |
| 1545807920 | 1 | < 0.1% |
| 7524950730 | 1 | < 0.1% |
| 2592220040 | 1 | < 0.1% |
| 6852700477 | 1 | < 0.1% |
| 3630160610 | 1 | < 0.1% |
| 1504800097 | 1 | < 0.1% |
| 8687800065 | 1 | < 0.1% |
| Other values (21200) | 21200 |
| Value | Count | Frequency (%) |
| 1000102 | 1 | |
| 1200019 | 1 | |
| 1200021 | 1 | |
| 2800031 | 1 | |
| 3600057 | 1 | |
| 3600072 | 1 | |
| 3800008 | 1 | |
| 5200087 | 1 | |
| 6200017 | 1 | |
| 7200080 | 1 |
| Value | Count | Frequency (%) |
| 9900000190 | 1 | |
| 9895000040 | 1 | |
| 9842300540 | 1 | |
| 9842300485 | 1 | |
| 9842300095 | 1 | |
| 9842300036 | 1 | |
| 9839301165 | 1 | |
| 9839301060 | 1 | |
| 9839301055 | 1 | |
| 9839300875 | 1 |
date
Date
| Distinct | 372 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 165.8 KiB |
| Minimum | 2014-05-02 00:00:00 |
|---|---|
| Maximum | 2015-05-27 00:00:00 |
price
Real number (ℝ)
High correlation 
| Distinct | 3919 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 526238.97 |
| Minimum | 75000 |
|---|---|
| Maximum | 4489000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 75000 |
|---|---|
| 5-th percentile | 212633.55 |
| Q1 | 322000 |
| median | 450000 |
| Q3 | 637500 |
| 95-th percentile | 1085775 |
| Maximum | 4489000 |
| Range | 4414000 |
| Interquartile range (IQR) | 315500 |
Descriptive statistics
| Standard deviation | 313627.9 |
|---|---|
| Coefficient of variation (CV) | 0.59598 |
| Kurtosis | 12.334217 |
| Mean | 526238.97 |
| Median Absolute Deviation (MAD) | 150000 |
| Skewness | 2.6013355 |
| Sum | 1.1161529 × 1010 |
| Variance | 9.8362462 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 450000 | 171 | 0.8% |
| 350000 | 167 | 0.8% |
| 550000 | 157 | 0.7% |
| 500000 | 151 | 0.7% |
| 425000 | 148 | 0.7% |
| 325000 | 146 | 0.7% |
| 400000 | 143 | 0.7% |
| 375000 | 137 | 0.6% |
| 300000 | 131 | 0.6% |
| 525000 | 128 | 0.6% |
| Other values (3909) | 19731 |
| Value | Count | Frequency (%) |
| 75000 | 1 | |
| 78000 | 1 | |
| 80000 | 1 | |
| 81000 | 1 | |
| 82500 | 1 | |
| 83000 | 1 | |
| 84000 | 1 | |
| 85000 | 1 | |
| 89000 | 1 | |
| 89950 | 1 |
| Value | Count | Frequency (%) |
| 4489000 | 1 | |
| 4000000 | 1 | |
| 3710000 | 1 | |
| 3650000 | 1 | |
| 3635000 | 1 | |
| 3418800 | 1 | |
| 3400000 | 1 | |
| 3204000 | 1 | |
| 3200000 | 1 | |
| 3100000 | 1 |
bedrooms
Real number (ℝ)
High correlation 
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3589816 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.88923322 |
|---|---|
| Coefficient of variation (CV) | 0.26473298 |
| Kurtosis | 0.95191765 |
| Mean | 3.3589816 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.37149875 |
| Sum | 71244 |
| Variance | 0.79073573 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 9691 | |
| 4 | 6778 | |
| 2 | 2722 | 12.8% |
| 5 | 1528 | 7.2% |
| 6 | 243 | 1.1% |
| 1 | 190 | 0.9% |
| 7 | 33 | 0.2% |
| 0 | 13 | 0.1% |
| 8 | 12 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 13 | 0.1% |
| 1 | 190 | 0.9% |
| 2 | 2722 | 12.8% |
| 3 | 9691 | |
| 4 | 6778 | |
| 5 | 1528 | 7.2% |
| 6 | 243 | 1.1% |
| 7 | 33 | 0.2% |
| 8 | 12 | 0.1% |
| Value | Count | Frequency (%) |
| 8 | 12 | 0.1% |
| 7 | 33 | 0.2% |
| 6 | 243 | 1.1% |
| 5 | 1528 | 7.2% |
| 4 | 6778 | |
| 3 | 9691 | |
| 2 | 2722 | 12.8% |
| 1 | 190 | 0.9% |
| 0 | 13 | 0.1% |
bathrooms
Real number (ℝ)
High correlation 
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1007426 |
| Minimum | 0 |
|---|---|
| Maximum | 6.5 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.5 |
| median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 6.5 |
| Range | 6.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.74420137 |
|---|---|
| Coefficient of variation (CV) | 0.35425634 |
| Kurtosis | 0.26798102 |
| Mean | 2.1007426 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.29959646 |
| Sum | 44556.75 |
| Variance | 0.55383567 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.5 | 5332 | |
| 1 | 3789 | |
| 1.75 | 3011 | |
| 2.25 | 2027 | 9.6% |
| 2 | 1910 | 9.0% |
| 1.5 | 1429 | 6.7% |
| 2.75 | 1169 | 5.5% |
| 3 | 736 | 3.5% |
| 3.5 | 708 | 3.3% |
| 3.25 | 564 | 2.7% |
| Other values (15) | 535 | 2.5% |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 0.5 | 4 | < 0.1% |
| 0.75 | 67 | 0.3% |
| 1 | 3789 | |
| 1.25 | 9 | < 0.1% |
| 1.5 | 1429 | 6.7% |
| 1.75 | 3011 | |
| 2 | 1910 | 9.0% |
| 2.25 | 2027 | 9.6% |
| 2.5 | 5332 |
| Value | Count | Frequency (%) |
| 6.5 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 5.75 | 1 | < 0.1% |
| 5.5 | 3 | < 0.1% |
| 5.25 | 9 | < 0.1% |
| 5 | 15 | 0.1% |
| 4.75 | 13 | 0.1% |
| 4.5 | 78 | |
| 4.25 | 62 | |
| 4 | 116 |
sqft_living
Real number (ℝ)
High correlation 
| Distinct | 967 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2053.7525 |
| Minimum | 290 |
|---|---|
| Maximum | 7320 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1420 |
| median | 1900 |
| Q3 | 2530 |
| 95-th percentile | 3673.1 |
| Maximum | 7320 |
| Range | 7030 |
| Interquartile range (IQR) | 1110 |
Descriptive statistics
| Standard deviation | 857.03547 |
|---|---|
| Coefficient of variation (CV) | 0.41730222 |
| Kurtosis | 1.3481802 |
| Mean | 2053.7525 |
| Median Absolute Deviation (MAD) | 540 |
| Skewness | 0.99409077 |
| Sum | 43560090 |
| Variance | 734509.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1300 | 135 | 0.6% |
| 1440 | 133 | 0.6% |
| 1400 | 132 | 0.6% |
| 1800 | 128 | 0.6% |
| 1660 | 128 | 0.6% |
| 1820 | 127 | 0.6% |
| 1560 | 124 | 0.6% |
| 1010 | 124 | 0.6% |
| 1540 | 122 | 0.6% |
| 1480 | 122 | 0.6% |
| Other values (957) | 19935 |
| Value | Count | Frequency (%) |
| 290 | 1 | |
| 370 | 1 | |
| 380 | 1 | |
| 384 | 1 | |
| 390 | 2 | |
| 410 | 1 | |
| 420 | 2 | |
| 430 | 1 | |
| 440 | 1 | |
| 460 | 1 |
| Value | Count | Frequency (%) |
| 7320 | 1 | |
| 7080 | 1 | |
| 6810 | 1 | |
| 6640 | 1 | |
| 6563 | 1 | |
| 6500 | 1 | |
| 6430 | 1 | |
| 6380 | 1 | |
| 6370 | 1 | |
| 6330 | 1 |
sqft_lot
Real number (ℝ)
High correlation 
| Distinct | 9638 |
|---|---|
| Distinct (%) | 45.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14422.315 |
| Minimum | 520 |
|---|---|
| Maximum | 1164794 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1779 |
| Q1 | 5020.25 |
| median | 7570.5 |
| Q3 | 10522.5 |
| 95-th percentile | 41807.85 |
| Maximum | 1164794 |
| Range | 1164274 |
| Interquartile range (IQR) | 5502.25 |
Descriptive statistics
| Standard deviation | 36749.945 |
|---|---|
| Coefficient of variation (CV) | 2.5481308 |
| Kurtosis | 217.84818 |
| Mean | 14422.315 |
| Median Absolute Deviation (MAD) | 2590.5 |
| Skewness | 11.582157 |
| Sum | 3.058973 × 108 |
| Variance | 1.3505584 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 354 | 1.7% |
| 6000 | 282 | 1.3% |
| 4000 | 248 | 1.2% |
| 7200 | 216 | 1.0% |
| 4800 | 118 | 0.6% |
| 7500 | 117 | 0.6% |
| 4500 | 112 | 0.5% |
| 8400 | 109 | 0.5% |
| 9600 | 108 | 0.5% |
| 3600 | 102 | 0.5% |
| Other values (9628) | 19444 |
| Value | Count | Frequency (%) |
| 520 | 1 | |
| 572 | 1 | |
| 600 | 1 | |
| 609 | 1 | |
| 635 | 1 | |
| 638 | 1 | |
| 649 | 2 | |
| 651 | 1 | |
| 675 | 1 | |
| 676 | 1 |
| Value | Count | Frequency (%) |
| 1164794 | 1 | |
| 1074218 | 1 | |
| 1024068 | 1 | |
| 982998 | 1 | |
| 982278 | 1 | |
| 843309 | 1 | |
| 715690 | 1 | |
| 641203 | 1 | |
| 623779 | 1 | |
| 577605 | 1 |
floors
Real number (ℝ)
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4926214 |
| Minimum | 1 |
|---|---|
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.53915024 |
|---|---|
| Coefficient of variation (CV) | 0.36121031 |
| Kurtosis | -0.48425389 |
| Mean | 1.4926214 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.61803565 |
| Sum | 31658.5 |
| Variance | 0.29068298 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 10507 | |
| 2 | 8083 | |
| 1.5 | 1871 | 8.8% |
| 3 | 599 | 2.8% |
| 2.5 | 143 | 0.7% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 10507 | |
| 1.5 | 1871 | 8.8% |
| 2 | 8083 | |
| 2.5 | 143 | 0.7% |
| 3 | 599 | 2.8% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.5 | 7 | < 0.1% |
| 3 | 599 | 2.8% |
| 2.5 | 143 | 0.7% |
| 2 | 8083 | |
| 1.5 | 1871 | 8.8% |
| 1 | 10507 |
waterfront
Categorical
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 165.8 KiB |
| 0 | |
|---|---|
| 1 | 76 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 21134 | |
| 1 | 76 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 21134 | |
| 1 | 76 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 21134 | |
| 1 | 76 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21134 | |
| 1 | 76 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21134 | |
| 1 | 76 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21134 | |
| 1 | 76 | 0.4% |
view
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 165.8 KiB |
| 0 | |
|---|---|
| 2 | 934 |
| 3 | 469 |
| 1 | 327 |
| 4 | 207 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 19273 | |
| 2 | 934 | 4.4% |
| 3 | 469 | 2.2% |
| 1 | 327 | 1.5% |
| 4 | 207 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 19273 | |
| 2 | 934 | 4.4% |
| 3 | 469 | 2.2% |
| 1 | 327 | 1.5% |
| 4 | 207 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 19273 | |
| 2 | 934 | 4.4% |
| 3 | 469 | 2.2% |
| 1 | 327 | 1.5% |
| 4 | 207 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19273 | |
| 2 | 934 | 4.4% |
| 3 | 469 | 2.2% |
| 1 | 327 | 1.5% |
| 4 | 207 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19273 | |
| 2 | 934 | 4.4% |
| 3 | 469 | 2.2% |
| 1 | 327 | 1.5% |
| 4 | 207 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19273 | |
| 2 | 934 | 4.4% |
| 3 | 469 | 2.2% |
| 1 | 327 | 1.5% |
| 4 | 207 | 1.0% |
condition
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 165.8 KiB |
| 3 | |
|---|---|
| 4 | |
| 5 | |
| 2 | 162 |
| 1 | 28 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 5 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 13763 | |
| 4 | 5596 | |
| 5 | 1661 | 7.8% |
| 2 | 162 | 0.8% |
| 1 | 28 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 13763 | |
| 4 | 5596 | |
| 5 | 1661 | 7.8% |
| 2 | 162 | 0.8% |
| 1 | 28 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 13763 | |
| 4 | 5596 | |
| 5 | 1661 | 7.8% |
| 2 | 162 | 0.8% |
| 1 | 28 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 13763 | |
| 4 | 5596 | |
| 5 | 1661 | 7.8% |
| 2 | 162 | 0.8% |
| 1 | 28 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 13763 | |
| 4 | 5596 | |
| 5 | 1661 | 7.8% |
| 2 | 162 | 0.8% |
| 1 | 28 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21210 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 13763 | |
| 4 | 5596 | |
| 5 | 1661 | 7.8% |
| 2 | 162 | 0.8% |
| 1 | 28 | 0.1% |
grade
Real number (ℝ)
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6365394 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1394594 |
|---|---|
| Coefficient of variation (CV) | 0.14921149 |
| Kurtosis | 0.99351896 |
| Mean | 7.6365394 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.68448489 |
| Sum | 161971 |
| Variance | 1.2983678 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 8880 | |
| 8 | 6022 | |
| 9 | 2584 | 12.2% |
| 6 | 1986 | 9.4% |
| 10 | 1086 | 5.1% |
| 11 | 331 | 1.6% |
| 5 | 232 | 1.1% |
| 12 | 52 | 0.2% |
| 4 | 29 | 0.1% |
| 13 | 4 | < 0.1% |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 29 | 0.1% |
| 5 | 232 | 1.1% |
| 6 | 1986 | 9.4% |
| 7 | 8880 | |
| 8 | 6022 | |
| 9 | 2584 | 12.2% |
| 10 | 1086 | 5.1% |
| 11 | 331 | 1.6% |
| Value | Count | Frequency (%) |
| 13 | 4 | < 0.1% |
| 12 | 52 | 0.2% |
| 11 | 331 | 1.6% |
| 10 | 1086 | 5.1% |
| 9 | 2584 | 12.2% |
| 8 | 6022 | |
| 7 | 8880 | |
| 6 | 1986 | 9.4% |
| 5 | 232 | 1.1% |
| 4 | 29 | 0.1% |
sqft_above
Real number (ℝ)
High correlation 
| Distinct | 900 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1770.6566 |
| Minimum | 290 |
|---|---|
| Maximum | 7320 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 850 |
| Q1 | 1190 |
| median | 1560 |
| Q3 | 2190 |
| 95-th percentile | 3320 |
| Maximum | 7320 |
| Range | 7030 |
| Interquartile range (IQR) | 1000 |
Descriptive statistics
| Standard deviation | 791.7542 |
|---|---|
| Coefficient of variation (CV) | 0.44715287 |
| Kurtosis | 1.6482237 |
| Mean | 1770.6566 |
| Median Absolute Deviation (MAD) | 450 |
| Skewness | 1.2112886 |
| Sum | 37555627 |
| Variance | 626874.71 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1300 | 209 | 1.0% |
| 1010 | 204 | 1.0% |
| 1200 | 203 | 1.0% |
| 1220 | 186 | 0.9% |
| 1140 | 183 | 0.9% |
| 1400 | 179 | 0.8% |
| 1180 | 176 | 0.8% |
| 1060 | 176 | 0.8% |
| 1340 | 174 | 0.8% |
| 1250 | 173 | 0.8% |
| Other values (890) | 19347 |
| Value | Count | Frequency (%) |
| 290 | 1 | |
| 370 | 1 | |
| 380 | 1 | |
| 384 | 1 | |
| 390 | 2 | |
| 410 | 1 | |
| 420 | 2 | |
| 430 | 1 | |
| 440 | 1 | |
| 460 | 1 |
| Value | Count | Frequency (%) |
| 7320 | 1 | |
| 6640 | 1 | |
| 6430 | 1 | |
| 6380 | 1 | |
| 6370 | 1 | |
| 6110 | 2 | |
| 6070 | 1 | |
| 5990 | 1 | |
| 5844 | 1 | |
| 5760 | 1 |
sqft_basement
Real number (ℝ)
High correlation  Zeros 
| Distinct | 278 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 283.09585 |
| Minimum | 0 |
|---|---|
| Maximum | 2850 |
| Zeros | 12955 |
| Zeros (%) | 61.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 550 |
| 95-th percentile | 1160 |
| Maximum | 2850 |
| Range | 2850 |
| Interquartile range (IQR) | 550 |
Descriptive statistics
| Standard deviation | 426.5906 |
|---|---|
| Coefficient of variation (CV) | 1.5068769 |
| Kurtosis | 1.3078512 |
| Mean | 283.09585 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4206391 |
| Sum | 6004463 |
| Variance | 181979.54 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12955 | |
| 600 | 217 | 1.0% |
| 700 | 214 | 1.0% |
| 500 | 210 | 1.0% |
| 800 | 205 | 1.0% |
| 400 | 184 | 0.9% |
| 900 | 143 | 0.7% |
| 1000 | 142 | 0.7% |
| 300 | 140 | 0.7% |
| 200 | 106 | 0.5% |
| Other values (268) | 6694 |
| Value | Count | Frequency (%) |
| 0 | 12955 | |
| 10 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 40 | 4 | < 0.1% |
| 50 | 11 | 0.1% |
| 60 | 10 | < 0.1% |
| 65 | 1 | < 0.1% |
| 70 | 7 | < 0.1% |
| 80 | 20 | 0.1% |
| 90 | 21 | 0.1% |
| Value | Count | Frequency (%) |
| 2850 | 1 | |
| 2720 | 1 | |
| 2610 | 1 | |
| 2570 | 1 | |
| 2350 | 1 | |
| 2330 | 1 | |
| 2250 | 1 | |
| 2220 | 2 | |
| 2200 | 1 | |
| 2196 | 1 |
yr_built
Real number (ℝ)
High correlation 
| Distinct | 116 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1971.1416 |
| Minimum | 1900 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1915 |
| Q1 | 1952 |
| median | 1975 |
| Q3 | 1997 |
| 95-th percentile | 2011 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 29.317482 |
|---|---|
| Coefficient of variation (CV) | 0.014873351 |
| Kurtosis | -0.64602845 |
| Mean | 1971.1416 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.47422058 |
| Sum | 41807913 |
| Variance | 859.51473 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2014 | 557 | 2.6% |
| 2006 | 450 | 2.1% |
| 2005 | 445 | 2.1% |
| 2004 | 424 | 2.0% |
| 2003 | 419 | 2.0% |
| 1977 | 414 | 2.0% |
| 2007 | 409 | 1.9% |
| 1978 | 381 | 1.8% |
| 1968 | 378 | 1.8% |
| 2008 | 362 | 1.7% |
| Other values (106) | 16971 |
| Value | Count | Frequency (%) |
| 1900 | 86 | |
| 1901 | 29 | 0.1% |
| 1902 | 27 | 0.1% |
| 1903 | 43 | |
| 1904 | 43 | |
| 1905 | 73 | |
| 1906 | 89 | |
| 1907 | 63 | |
| 1908 | 85 | |
| 1909 | 91 |
| Value | Count | Frequency (%) |
| 2015 | 38 | 0.2% |
| 2014 | 557 | |
| 2013 | 198 | 0.9% |
| 2012 | 169 | 0.8% |
| 2011 | 130 | 0.6% |
| 2010 | 141 | 0.7% |
| 2009 | 225 | |
| 2008 | 362 | |
| 2007 | 409 | |
| 2006 | 450 |
yr_renovated
Real number (ℝ)
Zeros 
| Distinct | 70 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.146865 |
| Minimum | 0 |
|---|---|
| Maximum | 2015 |
| Zeros | 20369 |
| Zeros (%) | 96.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 389.53362 |
|---|---|
| Coefficient of variation (CV) | 4.9216557 |
| Kurtosis | 20.272701 |
| Mean | 79.146865 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.7190157 |
| Sum | 1678705 |
| Variance | 151736.44 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20369 | |
| 2014 | 91 | 0.4% |
| 2013 | 36 | 0.2% |
| 2005 | 35 | 0.2% |
| 2007 | 35 | 0.2% |
| 2000 | 33 | 0.2% |
| 2003 | 31 | 0.1% |
| 2004 | 26 | 0.1% |
| 2006 | 21 | 0.1% |
| 1989 | 20 | 0.1% |
| Other values (60) | 513 | 2.4% |
| Value | Count | Frequency (%) |
| 0 | 20369 | |
| 1934 | 1 | < 0.1% |
| 1940 | 2 | < 0.1% |
| 1944 | 1 | < 0.1% |
| 1945 | 3 | < 0.1% |
| 1946 | 2 | < 0.1% |
| 1948 | 1 | < 0.1% |
| 1950 | 2 | < 0.1% |
| 1951 | 1 | < 0.1% |
| 1953 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2015 | 14 | 0.1% |
| 2014 | 91 | |
| 2013 | 36 | 0.2% |
| 2012 | 11 | 0.1% |
| 2011 | 13 | 0.1% |
| 2010 | 17 | 0.1% |
| 2009 | 20 | 0.1% |
| 2008 | 16 | 0.1% |
| 2007 | 35 | 0.2% |
| 2006 | 21 | 0.1% |
zipcode
Real number (ℝ)
High correlation 
| Distinct | 70 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98077.883 |
| Minimum | 98001 |
|---|---|
| Maximum | 98199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| median | 98065 |
| Q3 | 98117 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range (IQR) | 84 |
Descriptive statistics
| Standard deviation | 53.360672 |
|---|---|
| Coefficient of variation (CV) | 0.00054406427 |
| Kurtosis | -0.84862513 |
| Mean | 98077.883 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 0.40528652 |
| Sum | 2.0802319 × 109 |
| Variance | 2847.3613 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 98103 | 598 | 2.8% |
| 98038 | 585 | 2.8% |
| 98115 | 575 | 2.7% |
| 98052 | 570 | 2.7% |
| 98117 | 548 | 2.6% |
| 98042 | 546 | 2.6% |
| 98034 | 539 | 2.5% |
| 98118 | 497 | 2.3% |
| 98023 | 489 | 2.3% |
| 98133 | 485 | 2.3% |
| Other values (60) | 15778 |
| Value | Count | Frequency (%) |
| 98001 | 359 | |
| 98002 | 197 | |
| 98003 | 276 | |
| 98004 | 301 | |
| 98005 | 168 | 0.8% |
| 98006 | 471 | |
| 98007 | 139 | 0.7% |
| 98008 | 276 | |
| 98010 | 98 | 0.5% |
| 98011 | 194 |
| Value | Count | Frequency (%) |
| 98199 | 309 | |
| 98198 | 269 | |
| 98188 | 135 | 0.6% |
| 98178 | 257 | |
| 98177 | 239 | |
| 98168 | 264 | |
| 98166 | 242 | |
| 98155 | 438 | |
| 98148 | 56 | 0.3% |
| 98146 | 279 |
lat
Real number (ℝ)
High correlation 
| Distinct | 5023 |
|---|---|
| Distinct (%) | 23.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.560012 |
| Minimum | 47.1559 |
|---|---|
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3103 |
| Q1 | 47.470325 |
| median | 47.5719 |
| Q3 | 47.6782 |
| 95-th percentile | 47.7496 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.207875 |
Descriptive statistics
| Standard deviation | 0.13875891 |
|---|---|
| Coefficient of variation (CV) | 0.0029175541 |
| Kurtosis | -0.68311691 |
| Mean | 47.560012 |
| Median Absolute Deviation (MAD) | 0.105 |
| Skewness | -0.48474394 |
| Sum | 1008747.9 |
| Variance | 0.019254034 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 47.5322 | 17 | 0.1% |
| 47.5491 | 17 | 0.1% |
| 47.6624 | 17 | 0.1% |
| 47.6846 | 17 | 0.1% |
| 47.6886 | 16 | 0.1% |
| 47.6955 | 16 | 0.1% |
| 47.6711 | 16 | 0.1% |
| 47.686 | 15 | 0.1% |
| 47.5402 | 15 | 0.1% |
| 47.6647 | 15 | 0.1% |
| Other values (5013) | 21049 |
| Value | Count | Frequency (%) |
| 47.1559 | 1 | |
| 47.1593 | 1 | |
| 47.1622 | 1 | |
| 47.1647 | 1 | |
| 47.1764 | 1 | |
| 47.1775 | 1 | |
| 47.1776 | 2 | |
| 47.1795 | 1 | |
| 47.1803 | 1 | |
| 47.1808 | 1 |
| Value | Count | Frequency (%) |
| 47.7776 | 3 | |
| 47.7775 | 3 | |
| 47.7774 | 1 | < 0.1% |
| 47.7772 | 3 | |
| 47.7771 | 2 | < 0.1% |
| 47.777 | 2 | < 0.1% |
| 47.7769 | 3 | |
| 47.7768 | 2 | < 0.1% |
| 47.7767 | 6 | |
| 47.7766 | 4 |
long
Real number (ℝ)
High correlation 
| Distinct | 747 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.2138 |
| Minimum | -122.519 |
|---|---|
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 21210 |
| Negative (%) | 100.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| median | -122.23 |
| Q3 | -122.125 |
| 95-th percentile | -121.98 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range (IQR) | 0.203 |
Descriptive statistics
| Standard deviation | 0.14055389 |
|---|---|
| Coefficient of variation (CV) | -0.0011500656 |
| Kurtosis | 1.0355209 |
| Mean | -122.2138 |
| Median Absolute Deviation (MAD) | 0.101 |
| Skewness | 0.88005048 |
| Sum | -2592154.7 |
| Variance | 0.019755395 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -122.29 | 114 | 0.5% |
| -122.3 | 110 | 0.5% |
| -122.291 | 99 | 0.5% |
| -122.363 | 98 | 0.5% |
| -122.362 | 98 | 0.5% |
| -122.357 | 95 | 0.4% |
| -122.372 | 95 | 0.4% |
| -122.288 | 95 | 0.4% |
| -122.346 | 93 | 0.4% |
| -122.365 | 93 | 0.4% |
| Other values (737) | 20220 |
| Value | Count | Frequency (%) |
| -122.519 | 1 | < 0.1% |
| -122.515 | 1 | < 0.1% |
| -122.514 | 1 | < 0.1% |
| -122.512 | 1 | < 0.1% |
| -122.511 | 1 | < 0.1% |
| -122.509 | 2 | |
| -122.507 | 1 | < 0.1% |
| -122.506 | 1 | < 0.1% |
| -122.505 | 3 | |
| -122.504 | 2 |
| Value | Count | Frequency (%) |
| -121.315 | 2 | |
| -121.316 | 1 | |
| -121.319 | 1 | |
| -121.321 | 1 | |
| -121.325 | 1 | |
| -121.352 | 2 | |
| -121.359 | 1 | |
| -121.364 | 2 | |
| -121.402 | 1 | |
| -121.403 | 1 |
sqft_living15
Real number (ℝ)
High correlation 
| Distinct | 757 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1974.7783 |
| Minimum | 399 |
|---|---|
| Maximum | 5790 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1480 |
| median | 1830 |
| Q3 | 2350 |
| 95-th percentile | 3240 |
| Maximum | 5790 |
| Range | 5391 |
| Interquartile range (IQR) | 870 |
Descriptive statistics
| Standard deviation | 668.18396 |
|---|---|
| Coefficient of variation (CV) | 0.33835898 |
| Kurtosis | 1.3194834 |
| Mean | 1974.7783 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 1.0440776 |
| Sum | 41885047 |
| Variance | 446469.81 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1540 | 193 | 0.9% |
| 1440 | 190 | 0.9% |
| 1560 | 190 | 0.9% |
| 1500 | 179 | 0.8% |
| 1460 | 167 | 0.8% |
| 1800 | 165 | 0.8% |
| 1580 | 165 | 0.8% |
| 1720 | 165 | 0.8% |
| 1610 | 164 | 0.8% |
| 1620 | 163 | 0.8% |
| Other values (747) | 19469 |
| Value | Count | Frequency (%) |
| 399 | 1 | < 0.1% |
| 460 | 2 | < 0.1% |
| 620 | 2 | < 0.1% |
| 670 | 1 | < 0.1% |
| 690 | 2 | < 0.1% |
| 700 | 2 | < 0.1% |
| 710 | 2 | < 0.1% |
| 720 | 2 | < 0.1% |
| 740 | 8 | |
| 750 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 5790 | 5 | |
| 5600 | 1 | < 0.1% |
| 5330 | 1 | < 0.1% |
| 5200 | 1 | < 0.1% |
| 5170 | 1 | < 0.1% |
| 5110 | 1 | < 0.1% |
| 5080 | 1 | < 0.1% |
| 5030 | 1 | < 0.1% |
| 5000 | 1 | < 0.1% |
| 4950 | 1 | < 0.1% |
sqft_lot15
Real number (ℝ)
High correlation 
| Distinct | 8561 |
|---|---|
| Distinct (%) | 40.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12303.153 |
| Minimum | 651 |
|---|---|
| Maximum | 560617 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 651 |
|---|---|
| 5-th percentile | 1971.15 |
| Q1 | 5099.25 |
| median | 7600 |
| Q3 | 10012.75 |
| 95-th percentile | 36444 |
| Maximum | 560617 |
| Range | 559966 |
| Interquartile range (IQR) | 4913.5 |
Descriptive statistics
| Standard deviation | 24568.618 |
|---|---|
| Coefficient of variation (CV) | 1.9969368 |
| Kurtosis | 79.687615 |
| Mean | 12303.153 |
| Median Absolute Deviation (MAD) | 2492 |
| Skewness | 7.8191253 |
| Sum | 2.6094986 × 108 |
| Variance | 6.0361697 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 424 | 2.0% |
| 4000 | 354 | 1.7% |
| 6000 | 284 | 1.3% |
| 7200 | 207 | 1.0% |
| 4800 | 144 | 0.7% |
| 7500 | 142 | 0.7% |
| 8400 | 115 | 0.5% |
| 4500 | 110 | 0.5% |
| 3600 | 110 | 0.5% |
| 5100 | 109 | 0.5% |
| Other values (8551) | 19211 |
| Value | Count | Frequency (%) |
| 651 | 1 | < 0.1% |
| 659 | 1 | < 0.1% |
| 660 | 1 | < 0.1% |
| 748 | 2 | |
| 750 | 4 | |
| 755 | 1 | < 0.1% |
| 757 | 1 | < 0.1% |
| 758 | 1 | < 0.1% |
| 788 | 1 | < 0.1% |
| 794 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 560617 | 1 | |
| 438213 | 1 | |
| 434728 | 1 | |
| 392040 | 2 | |
| 380279 | 1 | |
| 360000 | 1 | |
| 358934 | 1 | |
| 339332 | 1 | |
| 335289 | 1 | |
| 326097 | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2014 |
|---|---|
| 2nd row | 2014 |
| 3rd row | 2015 |
| 4th row | 2014 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2014 | 14313 | |
| 2015 | 6897 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2014 | 14313 | |
| 2015 | 6897 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 21210 | |
| 0 | 21210 | |
| 1 | 21210 | |
| 4 | 14313 | |
| 5 | 6897 | 8.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84840 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 21210 | |
| 0 | 21210 | |
| 1 | 21210 | |
| 4 | 14313 | |
| 5 | 6897 | 8.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84840 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 21210 | |
| 0 | 21210 | |
| 1 | 21210 | |
| 4 | 14313 | |
| 5 | 6897 | 8.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84840 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 21210 | |
| 0 | 21210 | |
| 1 | 21210 | |
| 4 | 14313 | |
| 5 | 6897 | 8.1% |
age
Real number (ℝ)
High correlation  Zeros 
| Distinct | 116 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.932579 |
| Minimum | 0 |
|---|---|
| Maximum | 115 |
| Zeros | 530 |
| Zeros (%) | 2.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 165.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 15 |
| median | 37 |
| Q3 | 60 |
| 95-th percentile | 97 |
| Maximum | 115 |
| Range | 115 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 28.79275 |
|---|---|
| Coefficient of variation (CV) | 0.70341892 |
| Kurtosis | -0.52778385 |
| Mean | 40.932579 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.55321183 |
| Sum | 868180 |
| Variance | 829.02247 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 530 | 2.5% |
| 9 | 493 | 2.3% |
| 8 | 470 | 2.2% |
| 11 | 459 | 2.2% |
| 10 | 451 | 2.1% |
| 7 | 419 | 2.0% |
| 37 | 384 | 1.8% |
| 36 | 378 | 1.8% |
| 47 | 346 | 1.6% |
| 6 | 336 | 1.6% |
| Other values (106) | 16944 |
| Value | Count | Frequency (%) |
| 0 | 530 | |
| 1 | 328 | |
| 2 | 187 | 0.9% |
| 3 | 178 | 0.8% |
| 4 | 130 | 0.6% |
| 5 | 220 | |
| 6 | 336 | |
| 7 | 419 | |
| 8 | 470 | |
| 9 | 493 |
| Value | Count | Frequency (%) |
| 115 | 21 | 0.1% |
| 114 | 53 | |
| 113 | 27 | 0.1% |
| 112 | 31 | |
| 111 | 40 | |
| 110 | 43 | |
| 109 | 58 | |
| 108 | 70 | |
| 107 | 67 | |
| 106 | 62 |
Interactions
Correlations
| id | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | year | age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1.000 | -0.017 | 0.003 | 0.009 | -0.009 | -0.136 | 0.019 | 0.002 | 0.019 | -0.024 | 0.011 | -0.008 | -0.003 | 0.022 | -0.016 | -0.009 | -0.003 | 0.021 | -0.001 | -0.143 | 0.011 | -0.018 |
| price | -0.017 | 1.000 | 0.315 | 0.503 | 0.675 | 0.069 | 0.263 | 0.108 | 0.324 | 0.038 | 0.670 | 0.583 | 0.274 | 0.058 | 0.100 | -0.052 | 0.344 | 0.023 | 0.589 | 0.060 | 0.004 | -0.101 |
| bedrooms | 0.003 | 0.315 | 1.000 | 0.521 | 0.599 | 0.025 | 0.173 | -0.029 | 0.066 | 0.026 | 0.360 | 0.488 | 0.297 | 0.166 | 0.012 | -0.162 | -0.018 | 0.137 | 0.400 | 0.022 | -0.009 | -0.174 |
| bathrooms | 0.009 | 0.503 | 0.521 | 1.000 | 0.740 | 0.066 | 0.503 | 0.004 | 0.143 | -0.132 | 0.651 | 0.667 | 0.249 | 0.522 | 0.037 | -0.208 | 0.018 | 0.227 | 0.556 | 0.060 | -0.028 | -0.549 |
| sqft_living | -0.009 | 0.675 | 0.599 | 0.740 | 1.000 | 0.152 | 0.354 | 0.012 | 0.226 | -0.064 | 0.752 | 0.869 | 0.396 | 0.336 | 0.034 | -0.209 | 0.046 | 0.250 | 0.756 | 0.155 | -0.031 | -0.355 |
| sqft_lot | -0.136 | 0.069 | 0.025 | 0.066 | 0.152 | 1.000 | -0.016 | 0.019 | 0.046 | -0.009 | 0.096 | 0.166 | -0.004 | 0.055 | 0.001 | -0.134 | -0.087 | 0.230 | 0.138 | 0.695 | -0.004 | -0.052 |
| floors | 0.019 | 0.263 | 0.173 | 0.503 | 0.354 | -0.016 | 1.000 | 0.003 | 0.011 | -0.271 | 0.457 | 0.527 | -0.267 | 0.496 | 0.001 | -0.060 | 0.047 | 0.126 | 0.276 | -0.023 | -0.024 | -0.510 |
| waterfront | 0.002 | 0.108 | -0.029 | 0.004 | 0.012 | 0.019 | 0.003 | 1.000 | 0.292 | 0.017 | 0.018 | 0.003 | 0.018 | -0.021 | 0.016 | 0.037 | -0.019 | -0.037 | 0.028 | 0.020 | 0.002 | 0.019 |
| view | 0.019 | 0.324 | 0.066 | 0.143 | 0.226 | 0.046 | 0.011 | 0.292 | 1.000 | 0.046 | 0.206 | 0.113 | 0.244 | -0.056 | 0.060 | 0.091 | 0.004 | -0.082 | 0.245 | 0.045 | 0.001 | 0.036 |
| condition | -0.024 | 0.038 | 0.026 | -0.132 | -0.064 | -0.009 | -0.271 | 0.017 | 0.046 | 1.000 | -0.154 | -0.168 | 0.184 | -0.365 | -0.061 | 0.003 | -0.016 | -0.106 | -0.098 | -0.000 | -0.046 | 0.398 |
| grade | 0.011 | 0.670 | 0.360 | 0.651 | 0.752 | 0.096 | 0.457 | 0.018 | 0.206 | -0.154 | 1.000 | 0.746 | 0.126 | 0.458 | -0.003 | -0.189 | 0.111 | 0.200 | 0.703 | 0.099 | -0.034 | -0.467 |
| sqft_above | -0.008 | 0.583 | 0.488 | 0.667 | 0.869 | 0.166 | 0.527 | 0.003 | 0.113 | -0.168 | 0.746 | 1.000 | -0.110 | 0.441 | 0.007 | -0.272 | -0.009 | 0.356 | 0.730 | 0.171 | -0.027 | -0.448 |
| sqft_basement | -0.003 | 0.274 | 0.297 | 0.249 | 0.396 | -0.004 | -0.267 | 0.018 | 0.244 | 0.184 | 0.126 | -0.110 | 1.000 | -0.144 | 0.055 | 0.084 | 0.108 | -0.157 | 0.164 | -0.007 | -0.012 | 0.119 |
| yr_built | 0.022 | 0.058 | 0.166 | 0.522 | 0.336 | 0.055 | 0.496 | -0.021 | -0.056 | -0.365 | 0.458 | 0.441 | -0.144 | 1.000 | -0.220 | -0.346 | -0.151 | 0.408 | 0.333 | 0.072 | 0.002 | -0.913 |
| yr_renovated | -0.016 | 0.100 | 0.012 | 0.037 | 0.034 | 0.001 | 0.001 | 0.016 | 0.060 | -0.061 | -0.003 | 0.007 | 0.055 | -0.220 | 1.000 | 0.064 | 0.030 | -0.065 | -0.022 | -0.000 | -0.026 | -0.161 |
| zipcode | -0.009 | -0.052 | -0.162 | -0.208 | -0.209 | -0.134 | -0.060 | 0.037 | 0.091 | 0.003 | -0.189 | -0.272 | 0.084 | -0.346 | 0.064 | 1.000 | 0.268 | -0.564 | -0.283 | -0.153 | 0.004 | 0.320 |
| lat | -0.003 | 0.344 | -0.018 | 0.018 | 0.046 | -0.087 | 0.047 | -0.019 | 0.004 | -0.016 | 0.111 | -0.009 | 0.108 | -0.151 | 0.030 | 0.268 | 1.000 | -0.137 | 0.045 | -0.088 | -0.030 | 0.138 |
| long | 0.021 | 0.023 | 0.137 | 0.227 | 0.250 | 0.230 | 0.126 | -0.037 | -0.082 | -0.106 | 0.200 | 0.356 | -0.157 | 0.408 | -0.065 | -0.564 | -0.137 | 1.000 | 0.340 | 0.257 | -0.002 | -0.383 |
| sqft_living15 | -0.001 | 0.589 | 0.400 | 0.556 | 0.756 | 0.138 | 0.276 | 0.028 | 0.245 | -0.098 | 0.703 | 0.730 | 0.164 | 0.333 | -0.022 | -0.283 | 0.045 | 0.340 | 1.000 | 0.175 | -0.024 | -0.325 |
| sqft_lot15 | -0.143 | 0.060 | 0.022 | 0.060 | 0.155 | 0.695 | -0.023 | 0.020 | 0.045 | -0.000 | 0.099 | 0.171 | -0.007 | 0.072 | -0.000 | -0.153 | -0.088 | 0.257 | 0.175 | 1.000 | -0.008 | -0.068 |
| year | 0.011 | 0.004 | -0.009 | -0.028 | -0.031 | -0.004 | -0.024 | 0.002 | 0.001 | -0.046 | -0.034 | -0.027 | -0.012 | 0.002 | -0.026 | 0.004 | -0.030 | -0.002 | -0.024 | -0.008 | 1.000 | 0.025 |
| age | -0.018 | -0.101 | -0.174 | -0.549 | -0.355 | -0.052 | -0.510 | 0.019 | 0.036 | 0.398 | -0.467 | -0.448 | 0.119 | -0.913 | -0.161 | 0.320 | 0.138 | -0.383 | -0.325 | -0.068 | 0.025 | 1.000 |
| id | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | year | age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1.000 | 0.081 | 0.041 | 0.073 | 0.079 | 0.121 | 0.081 | 0.017 | 0.069 | 0.071 | 0.112 | 0.091 | 0.084 | 0.162 | 0.034 | 0.350 | 0.268 | 0.326 | 0.116 | 0.105 | 0.011 | 0.153 |
| price | 0.081 | 1.000 | 0.249 | 0.584 | 0.697 | 0.000 | 0.243 | 0.161 | 0.387 | 0.101 | 0.668 | 0.657 | 0.320 | 0.191 | 0.129 | 0.312 | 0.519 | 0.238 | 0.573 | 0.000 | 0.000 | 0.211 |
| bedrooms | 0.041 | 0.249 | 1.000 | 0.558 | 0.521 | 0.000 | 0.279 | 0.028 | 0.065 | 0.091 | 0.416 | 0.452 | 0.282 | 0.277 | 0.025 | 0.221 | 0.137 | 0.202 | 0.345 | 0.000 | 0.009 | 0.281 |
| bathrooms | 0.073 | 0.584 | 0.558 | 1.000 | 0.762 | 0.003 | 0.447 | 0.000 | 0.208 | 0.270 | 0.695 | 0.689 | 0.366 | 0.575 | 0.092 | 0.318 | 0.250 | 0.304 | 0.570 | 0.026 | 0.037 | 0.584 |
| sqft_living | 0.079 | 0.697 | 0.521 | 0.762 | 1.000 | 0.097 | 0.379 | 0.038 | 0.275 | 0.172 | 0.761 | 0.957 | 0.587 | 0.422 | 0.054 | 0.339 | 0.231 | 0.323 | 0.766 | 0.078 | 0.033 | 0.438 |
| sqft_lot | 0.121 | 0.000 | 0.000 | 0.003 | 0.097 | 1.000 | 0.030 | 0.044 | 0.063 | 0.072 | 0.083 | 0.126 | 0.055 | 0.087 | 0.000 | 0.128 | 0.180 | 0.231 | 0.076 | 0.570 | 0.000 | 0.092 |
| floors | 0.081 | 0.243 | 0.279 | 0.447 | 0.379 | 0.030 | 1.000 | 0.025 | 0.023 | 0.262 | 0.368 | 0.505 | 0.247 | 0.622 | 0.075 | 0.340 | 0.250 | 0.306 | 0.335 | 0.053 | 0.032 | 0.612 |
| waterfront | 0.017 | 0.161 | 0.028 | 0.000 | 0.038 | 0.044 | 0.025 | 1.000 | 0.380 | 0.020 | 0.030 | 0.018 | 0.022 | 0.036 | 0.019 | 0.102 | 0.054 | 0.117 | 0.054 | 0.000 | 0.000 | 0.034 |
| view | 0.069 | 0.387 | 0.065 | 0.208 | 0.275 | 0.063 | 0.023 | 0.380 | 1.000 | 0.065 | 0.240 | 0.148 | 0.310 | 0.106 | 0.053 | 0.170 | 0.156 | 0.194 | 0.298 | 0.055 | 0.000 | 0.079 |
| condition | 0.071 | 0.101 | 0.091 | 0.270 | 0.172 | 0.072 | 0.262 | 0.020 | 0.065 | 1.000 | 0.349 | 0.259 | 0.231 | 0.532 | 0.056 | 0.177 | 0.138 | 0.191 | 0.151 | 0.014 | 0.042 | 0.554 |
| grade | 0.112 | 0.668 | 0.416 | 0.695 | 0.761 | 0.083 | 0.368 | 0.030 | 0.240 | 0.349 | 1.000 | 0.757 | 0.253 | 0.498 | 0.029 | 0.327 | 0.327 | 0.298 | 0.731 | 0.054 | 0.037 | 0.504 |
| sqft_above | 0.091 | 0.657 | 0.452 | 0.689 | 0.957 | 0.126 | 0.505 | 0.018 | 0.148 | 0.259 | 0.757 | 1.000 | 0.283 | 0.536 | 0.052 | 0.427 | 0.230 | 0.402 | 0.748 | 0.094 | 0.030 | 0.541 |
| sqft_basement | 0.084 | 0.320 | 0.282 | 0.366 | 0.587 | 0.055 | 0.247 | 0.022 | 0.310 | 0.231 | 0.253 | 0.283 | 1.000 | 0.313 | 0.078 | 0.234 | 0.171 | 0.230 | 0.307 | 0.000 | 0.020 | 0.283 |
| yr_built | 0.162 | 0.191 | 0.277 | 0.575 | 0.422 | 0.087 | 0.622 | 0.036 | 0.106 | 0.532 | 0.498 | 0.536 | 0.313 | 1.000 | 0.297 | 0.622 | 0.446 | 0.542 | 0.407 | 0.072 | 0.020 | 0.997 |
| yr_renovated | 0.034 | 0.129 | 0.025 | 0.092 | 0.054 | 0.000 | 0.075 | 0.019 | 0.053 | 0.056 | 0.029 | 0.052 | 0.078 | 0.297 | 1.000 | 0.115 | 0.077 | 0.098 | 0.017 | 0.000 | 0.038 | 0.221 |
| zipcode | 0.350 | 0.312 | 0.221 | 0.318 | 0.339 | 0.128 | 0.340 | 0.102 | 0.170 | 0.177 | 0.327 | 0.427 | 0.234 | 0.622 | 0.115 | 1.000 | 0.794 | 0.786 | 0.451 | 0.131 | 0.016 | 0.606 |
| lat | 0.268 | 0.519 | 0.137 | 0.250 | 0.231 | 0.180 | 0.250 | 0.054 | 0.156 | 0.138 | 0.327 | 0.230 | 0.171 | 0.446 | 0.077 | 0.794 | 1.000 | 0.492 | 0.286 | 0.135 | 0.044 | 0.438 |
| long | 0.326 | 0.238 | 0.202 | 0.304 | 0.323 | 0.231 | 0.306 | 0.117 | 0.194 | 0.191 | 0.298 | 0.402 | 0.230 | 0.542 | 0.098 | 0.786 | 0.492 | 1.000 | 0.433 | 0.212 | 0.025 | 0.527 |
| sqft_living15 | 0.116 | 0.573 | 0.345 | 0.570 | 0.766 | 0.076 | 0.335 | 0.054 | 0.298 | 0.151 | 0.731 | 0.748 | 0.307 | 0.407 | 0.017 | 0.451 | 0.286 | 0.433 | 1.000 | 0.087 | 0.022 | 0.402 |
| sqft_lot15 | 0.105 | 0.000 | 0.000 | 0.026 | 0.078 | 0.570 | 0.053 | 0.000 | 0.055 | 0.014 | 0.054 | 0.094 | 0.000 | 0.072 | 0.000 | 0.131 | 0.135 | 0.212 | 0.087 | 1.000 | 0.000 | 0.073 |
| year | 0.011 | 0.000 | 0.009 | 0.037 | 0.033 | 0.000 | 0.032 | 0.000 | 0.000 | 0.042 | 0.037 | 0.030 | 0.020 | 0.020 | 0.038 | 0.016 | 0.044 | 0.025 | 0.022 | 0.000 | 1.000 | 0.051 |
| age | 0.153 | 0.211 | 0.281 | 0.584 | 0.438 | 0.092 | 0.612 | 0.034 | 0.079 | 0.554 | 0.504 | 0.541 | 0.283 | 0.997 | 0.221 | 0.606 | 0.438 | 0.527 | 0.402 | 0.073 | 0.051 | 1.000 |
| age | bathrooms | bedrooms | condition | floors | grade | id | lat | long | price | sqft_above | sqft_basement | sqft_living | sqft_living15 | sqft_lot | sqft_lot15 | view | waterfront | year | yr_built | yr_renovated | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| age | 1.000 | -0.595 | -0.187 | 0.262 | -0.579 | -0.512 | -0.023 | 0.113 | -0.371 | -0.144 | -0.485 | 0.159 | -0.372 | -0.326 | 0.073 | 0.052 | 0.033 | 0.026 | 0.039 | -0.916 | -0.173 | 0.277 |
| bathrooms | -0.595 | 1.000 | 0.517 | 0.115 | 0.545 | 0.651 | 0.017 | 0.004 | 0.263 | 0.484 | 0.684 | 0.179 | 0.740 | 0.563 | 0.055 | 0.051 | 0.088 | 0.000 | 0.028 | 0.574 | 0.032 | -0.205 |
| bedrooms | -0.187 | 0.517 | 1.000 | 0.052 | 0.222 | 0.375 | 0.007 | -0.027 | 0.192 | 0.337 | 0.536 | 0.222 | 0.646 | 0.441 | 0.213 | 0.199 | 0.038 | 0.028 | 0.009 | 0.181 | 0.012 | -0.168 |
| condition | 0.262 | 0.115 | 0.052 | 1.000 | 0.181 | 0.156 | 0.030 | 0.058 | 0.081 | 0.042 | 0.110 | 0.098 | 0.072 | 0.063 | 0.030 | 0.008 | 0.024 | 0.025 | 0.051 | 0.249 | 0.069 | 0.074 |
| floors | -0.579 | 0.545 | 0.222 | 0.181 | 1.000 | 0.499 | 0.019 | 0.022 | 0.150 | 0.315 | 0.597 | -0.284 | 0.396 | 0.301 | -0.245 | -0.241 | 0.015 | 0.018 | 0.023 | 0.559 | 0.007 | -0.062 |
| grade | -0.512 | 0.651 | 0.375 | 0.156 | 0.499 | 1.000 | 0.021 | 0.100 | 0.223 | 0.649 | 0.706 | 0.077 | 0.710 | 0.656 | 0.139 | 0.144 | 0.110 | 0.026 | 0.028 | 0.504 | 0.003 | -0.181 |
| id | -0.023 | 0.017 | 0.007 | 0.030 | 0.019 | 0.021 | 1.000 | -0.005 | 0.008 | 0.005 | 0.005 | 0.002 | 0.003 | 0.001 | -0.115 | -0.114 | 0.029 | 0.013 | 0.008 | 0.027 | -0.016 | -0.006 |
| lat | 0.113 | 0.004 | -0.027 | 0.058 | 0.022 | 0.100 | -0.005 | 1.000 | -0.144 | 0.461 | -0.031 | 0.114 | 0.026 | 0.024 | -0.123 | -0.117 | 0.065 | 0.041 | 0.033 | -0.128 | 0.026 | 0.250 |
| long | -0.371 | 0.263 | 0.192 | 0.081 | 0.150 | 0.223 | 0.008 | -0.144 | 1.000 | 0.061 | 0.389 | -0.206 | 0.287 | 0.384 | 0.374 | 0.375 | 0.082 | 0.090 | 0.019 | 0.410 | -0.071 | -0.576 |
| price | -0.144 | 0.484 | 0.337 | 0.042 | 0.315 | 0.649 | 0.005 | 0.461 | 0.061 | 1.000 | 0.530 | 0.240 | 0.635 | 0.562 | 0.059 | 0.048 | 0.171 | 0.123 | 0.000 | 0.098 | 0.088 | -0.004 |
| sqft_above | -0.485 | 0.684 | 0.536 | 0.110 | 0.597 | 0.706 | 0.005 | -0.031 | 0.389 | 0.530 | 1.000 | -0.186 | 0.840 | 0.693 | 0.263 | 0.246 | 0.062 | 0.014 | 0.023 | 0.477 | 0.019 | -0.281 |
| sqft_basement | 0.159 | 0.179 | 0.222 | 0.098 | -0.284 | 0.077 | 0.002 | 0.114 | -0.206 | 0.240 | -0.186 | 1.000 | 0.316 | 0.115 | 0.026 | 0.020 | 0.134 | 0.017 | 0.015 | -0.183 | 0.052 | 0.119 |
| sqft_living | -0.372 | 0.740 | 0.646 | 0.072 | 0.396 | 0.710 | 0.003 | 0.026 | 0.287 | 0.635 | 0.840 | 0.316 | 1.000 | 0.743 | 0.294 | 0.275 | 0.117 | 0.029 | 0.026 | 0.356 | 0.038 | -0.208 |
| sqft_living15 | -0.326 | 0.563 | 0.441 | 0.063 | 0.301 | 0.656 | 0.001 | 0.024 | 0.384 | 0.562 | 0.693 | 0.115 | 0.743 | 1.000 | 0.351 | 0.358 | 0.128 | 0.042 | 0.017 | 0.338 | -0.021 | -0.289 |
| sqft_lot | 0.073 | 0.055 | 0.213 | 0.030 | -0.245 | 0.139 | -0.115 | -0.123 | 0.374 | 0.059 | 0.263 | 0.026 | 0.294 | 0.351 | 1.000 | 0.922 | 0.026 | 0.034 | 0.000 | -0.041 | -0.005 | -0.322 |
| sqft_lot15 | 0.052 | 0.051 | 0.199 | 0.008 | -0.241 | 0.144 | -0.114 | -0.117 | 0.375 | 0.048 | 0.246 | 0.020 | 0.275 | 0.358 | 0.922 | 1.000 | 0.031 | 0.000 | 0.000 | -0.020 | -0.004 | -0.328 |
| view | 0.033 | 0.088 | 0.038 | 0.024 | 0.015 | 0.110 | 0.029 | 0.065 | 0.082 | 0.171 | 0.062 | 0.134 | 0.117 | 0.128 | 0.026 | 0.031 | 1.000 | 0.463 | 0.000 | 0.044 | 0.065 | 0.071 |
| waterfront | 0.026 | 0.000 | 0.028 | 0.025 | 0.018 | 0.026 | 0.013 | 0.041 | 0.090 | 0.123 | 0.014 | 0.017 | 0.029 | 0.042 | 0.034 | 0.000 | 0.463 | 1.000 | 0.000 | 0.029 | 0.012 | 0.078 |
| year | 0.039 | 0.028 | 0.009 | 0.051 | 0.023 | 0.028 | 0.008 | 0.033 | 0.019 | 0.000 | 0.023 | 0.015 | 0.026 | 0.017 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.015 | 0.024 | 0.012 |
| yr_built | -0.916 | 0.574 | 0.181 | 0.249 | 0.559 | 0.504 | 0.027 | -0.128 | 0.410 | 0.098 | 0.477 | -0.183 | 0.356 | 0.338 | -0.041 | -0.020 | 0.044 | 0.029 | 0.015 | 1.000 | -0.210 | -0.315 |
| yr_renovated | -0.173 | 0.032 | 0.012 | 0.069 | 0.007 | 0.003 | -0.016 | 0.026 | -0.071 | 0.088 | 0.019 | 0.052 | 0.038 | -0.021 | -0.005 | -0.004 | 0.065 | 0.012 | 0.024 | -0.210 | 1.000 | 0.064 |
| zipcode | 0.277 | -0.205 | -0.168 | 0.074 | -0.062 | -0.181 | -0.006 | 0.250 | -0.576 | -0.004 | -0.281 | 0.119 | -0.208 | -0.289 | -0.322 | -0.328 | 0.071 | 0.078 | 0.012 | -0.315 | 0.064 | 1.000 |
Missing values
Sample
| id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | year | age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 7129300520 | 2014-10-13 | 221900.0 | 3 | 1.00 | 1180 | 5650 | 1.0 | 0 | 0 | 3 | 7 | 1180 | 0 | 1955 | 0 | 98178 | 47.5112 | -122.257 | 1340 | 5650 | 2014 | 59 |
| 1 | 6414100192 | 2014-12-09 | 538000.0 | 3 | 2.25 | 2570 | 7242 | 2.0 | 0 | 0 | 3 | 7 | 2170 | 400 | 1951 | 1991 | 98125 | 47.7210 | -122.319 | 1690 | 7639 | 2014 | 23 |
| 2 | 5631500400 | 2015-02-25 | 180000.0 | 2 | 1.00 | 770 | 10000 | 1.0 | 0 | 0 | 3 | 6 | 770 | 0 | 1933 | 0 | 98028 | 47.7379 | -122.233 | 2720 | 8062 | 2015 | 82 |
| 3 | 2487200875 | 2014-12-09 | 604000.0 | 4 | 3.00 | 1960 | 5000 | 1.0 | 0 | 0 | 5 | 7 | 1050 | 910 | 1965 | 0 | 98136 | 47.5208 | -122.393 | 1360 | 5000 | 2014 | 49 |
| 4 | 1954400510 | 2015-02-18 | 510000.0 | 3 | 2.00 | 1680 | 8080 | 1.0 | 0 | 0 | 3 | 8 | 1680 | 0 | 1987 | 0 | 98074 | 47.6168 | -122.045 | 1800 | 7503 | 2015 | 28 |
| 5 | 1321400060 | 2014-06-27 | 257500.0 | 3 | 2.25 | 1715 | 6819 | 2.0 | 0 | 0 | 3 | 7 | 1715 | 0 | 1995 | 0 | 98003 | 47.3097 | -122.327 | 2238 | 6819 | 2014 | 19 |
| 6 | 2008000270 | 2015-01-15 | 291850.0 | 3 | 1.50 | 1060 | 9711 | 1.0 | 0 | 0 | 3 | 7 | 1060 | 0 | 1963 | 0 | 98198 | 47.4095 | -122.315 | 1650 | 9711 | 2015 | 52 |
| 7 | 2414600126 | 2015-04-15 | 229500.0 | 3 | 1.00 | 1780 | 7470 | 1.0 | 0 | 0 | 3 | 7 | 1050 | 730 | 1960 | 0 | 98146 | 47.5123 | -122.337 | 1780 | 8113 | 2015 | 55 |
| 8 | 3793500160 | 2015-03-12 | 323000.0 | 3 | 2.50 | 1890 | 6560 | 2.0 | 0 | 0 | 3 | 7 | 1890 | 0 | 2003 | 0 | 98038 | 47.3684 | -122.031 | 2390 | 7570 | 2015 | 12 |
| 9 | 1736800520 | 2015-04-03 | 662500.0 | 3 | 2.50 | 3560 | 9796 | 1.0 | 0 | 0 | 3 | 8 | 1860 | 1700 | 1965 | 0 | 98007 | 47.6007 | -122.145 | 2210 | 8925 | 2015 | 50 |
| id | date | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | year | age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21200 | 7852140040 | 2014-08-25 | 507250.0 | 3 | 2.50 | 2270 | 5536 | 2.0 | 0 | 0 | 3 | 8 | 2270 | 0 | 2003 | 0 | 98065 | 47.5389 | -121.881 | 2270 | 5731 | 2014 | 11 |
| 21201 | 9834201367 | 2015-01-26 | 429000.0 | 3 | 2.00 | 1490 | 1126 | 3.0 | 0 | 0 | 3 | 8 | 1490 | 0 | 2014 | 0 | 98144 | 47.5699 | -122.288 | 1400 | 1230 | 2015 | 1 |
| 21202 | 3448900210 | 2014-10-14 | 610685.0 | 4 | 2.50 | 2520 | 6023 | 2.0 | 0 | 0 | 3 | 9 | 2520 | 0 | 2014 | 0 | 98056 | 47.5137 | -122.167 | 2520 | 6023 | 2014 | 0 |
| 21203 | 7936000429 | 2015-03-26 | 1007500.0 | 4 | 3.50 | 3510 | 7200 | 2.0 | 0 | 0 | 3 | 9 | 2600 | 910 | 2009 | 0 | 98136 | 47.5537 | -122.398 | 2050 | 6200 | 2015 | 6 |
| 21204 | 2997800021 | 2015-02-19 | 475000.0 | 3 | 2.50 | 1310 | 1294 | 2.0 | 0 | 0 | 3 | 8 | 1180 | 130 | 2008 | 0 | 98116 | 47.5773 | -122.409 | 1330 | 1265 | 2015 | 7 |
| 21205 | 263000018 | 2014-05-21 | 360000.0 | 3 | 2.50 | 1530 | 1131 | 3.0 | 0 | 0 | 3 | 8 | 1530 | 0 | 2009 | 0 | 98103 | 47.6993 | -122.346 | 1530 | 1509 | 2014 | 5 |
| 21206 | 6600060120 | 2015-02-23 | 400000.0 | 4 | 2.50 | 2310 | 5813 | 2.0 | 0 | 0 | 3 | 8 | 2310 | 0 | 2014 | 0 | 98146 | 47.5107 | -122.362 | 1830 | 7200 | 2015 | 1 |
| 21207 | 1523300141 | 2014-06-23 | 402101.0 | 2 | 0.75 | 1020 | 1350 | 2.0 | 0 | 0 | 3 | 7 | 1020 | 0 | 2009 | 0 | 98144 | 47.5944 | -122.299 | 1020 | 2007 | 2014 | 5 |
| 21208 | 291310100 | 2015-01-16 | 400000.0 | 3 | 2.50 | 1600 | 2388 | 2.0 | 0 | 0 | 3 | 8 | 1600 | 0 | 2004 | 0 | 98027 | 47.5345 | -122.069 | 1410 | 1287 | 2015 | 11 |
| 21209 | 1523300157 | 2014-10-15 | 325000.0 | 2 | 0.75 | 1020 | 1076 | 2.0 | 0 | 0 | 3 | 7 | 1020 | 0 | 2008 | 0 | 98144 | 47.5941 | -122.299 | 1020 | 1357 | 2014 | 6 |